Spread WPF 17
GrapeCity.CalcEngine.Functions Namespace / CalcAddressFunction Class / Evaluate Method / Evaluate(Object[]) Method

The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

Row_num is the row number to use in the cell reference.

Column_num is the column number to use in the cell reference.

[Abs_num] specifies the type of reference to return

[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.



In This Topic
    Evaluate(Object[]) Method
    In This Topic
    Creates a cell address as text, given specified row and column numbers.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function Evaluate( _
       ByVal args() As Object _
    ) As Object
    'Usage
     
    Dim instance As CalcAddressFunction
    Dim args() As Object
    Dim value As Object
     
    value = instance.Evaluate(args)
    public override object Evaluate( 
       object[] args
    )

    Parameters

    args

    The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

    Row_num is the row number to use in the cell reference.

    Column_num is the column number to use in the cell reference.

    [Abs_num] specifies the type of reference to return

    [A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

    [Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

    Return Value

    A System.Object value that indicates the evaluate result.
    See Also